Discussion board
Explain TIMESTAMP DEFAULT '2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP. ?
By Abhijit Paul
Explain TIMESTAMP DEFAULT '2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP. ?
Reply
Post   Reset
Teacher SiliconIndia replied to Abhijit Paul Thursday, March 18, 2010
Hi Abhijit,
A default value is used on initialization, a current timestamp is inserted on update of the row.